The SAS^® Regular Price Optimization DI_TRANS.PURGE_QUERY table might not contain an entry where the TABLE_NM is RPO_GEO_PROD_AGG. If there is no entry for RPO_GEO_PROD_AGG, then this table is not purged when the %DI_MAINTAIN_JOB is run.

To workaround this issue, run the following code in a SAS^® session where the SAS^® Merchandise Intelligence libraries are allocated:

proc sql;
insert into di_trans.purge_query
   (table_nm, database_nm, purge_order, num_days_preserved, purge_frequency, purge_query_txt, partition_flg, app_nm)
   values ('RPO_GEO_PROD_AGG','RBDMS', 2, 921, 30, '%di_purge_rpo_geo_prod_agg(libref=di_trans);', 0, 'RPO');
quit;

Operating System and Release Information